FinancialLedger

Entity Definition

Logical Name : FinancialLedger
Physical Name : LE_FN

A reporting period historical record of the beginning balance and cumulative activity for a FinancialLedgerAccount.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
FinancialLedgerID (FK)(PK) The reference for the FinancialLedgeraAccount ID_ACNT_LDG Identity integer FinancialLedgerAccount(CO_LE_ACNT_FN)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
BeginningAmount The opening balance for each account for a specific fiscal period on the STORE FINNCIAL LEDGER. MO_BGN_FSC_PRD Money decimal(16,5)
CumulativeAmount The cumulative monetary amount of each account for a specific fiscal period on the STORE FINNCIAL LEDGER. MO_CM_FSC_PRD Money decimal(16,5)
StatusCode A code to denote the status of the STORE FINANCIAL LEDGER for a specific fiscal period, ie open or closed. SC_PRD Code2Status char(2)

Relationships

Parent Entity Verb Phrase Child Entity
FinancialLedgerAccount is tracked by FinancialLedger
ReportingPeriod delineates FinancialLedger

Logical Views containing FinancialLedger

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 04000 - Financial Ledger - Macro View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 04300 - Financial Ledger - Inventory Control View